-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of ForumReply table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.ForumReply', 'U') IS NOT NULL
  DROP TABLE dbo.ForumReply
GO

CREATE TABLE dbo.ForumReply
(
	ReplyId int identity(1,1) NOT NULL, 
	AuthorId uniqueidentifier foreign key references aspnet_users(UserId) NOT NULL, 
	[Content] nvarchar(max) NOT NULL, 
	ts timestamp NULL,
    CONSTRAINT PK_Reply PRIMARY KEY (ReplyId)
)
GO
